The problem originated from a 12c database of the customer and needs to be started to the non-real time apply mode, but the execution is found:Alter database recover managed standby database cancel;Alter database recover managed standby database
For non-Data Guard patch installation tutorials, refer to [Oracle] CPU/PSU patch installation detailed tutorial. Data Guard requires both Primary and Standby patches, so the steps are more complex, the main steps are as follows:1. Stop the log
12c Dataguard provides a new syntax for implementing DG Switchover. Below is the test.
Master Library Execution Check
Sql> ALTER DATABASE switchover to Orcldg VERIFY; --Main library for switch checkALTER DATABASE switchover to Orcldg VERIFY*ERROR
Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as
Configure Flashbash Database Parameters
ALTER system SET db_recovery_file_dest= '/dg/fra ';ALTER system SET db_recovery_file_dest_size=10g;ALTER system SET db_flashback_retention_target=1440;ALTER DATABASE flashback on;
Primary library to build
Environment Introduction: a two-node single-instance Linux + oracle11.2.0.3 + customized uard maximize availability environment was set up a few days ago.
Fault description: synchronization failed today. An error message is found in the trace file
To test a DG problem, set up a test environment on Vmware and place primary and standby on the same host.I will not repeat the setup process, but I encountered some problems at the end. Record them here for future reference.
---- Some commands
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.